Pandas Profiling Report

Dataset statistics

Number of variables	18
Number of observations	6514792
Missing cells	8402940
Missing cells (%)	7.2%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	894.7 MiB
Average record size in memory	144.0 B

Variable types

Numeric	7
Categorical	11

Alerts

`start_time` has a high cardinality: 5259 distinct values	High cardinality
`blueprint` has a high cardinality: 433 distinct values	High cardinality
`login` has a high cardinality: 1144 distinct values	High cardinality
`position_x` is highly correlated with `map_width` and 1 other fields	High correlation
`position_y` is highly correlated with `map_width` and 1 other fields	High correlation
`map_width` is highly correlated with `position_x` and 2 other fields	High correlation
`map_height` is highly correlated with `position_x` and 2 other fields	High correlation
`position_x` is highly correlated with `map_width` and 1 other fields	High correlation
`position_y` is highly correlated with `map_width` and 1 other fields	High correlation
`map_width` is highly correlated with `position_x` and 2 other fields	High correlation
`map_height` is highly correlated with `position_x` and 2 other fields	High correlation
`position_y` is highly correlated with `map_width` and 1 other fields	High correlation
`map_width` is highly correlated with `position_y` and 1 other fields	High correlation
`map_height` is highly correlated with `position_y` and 1 other fields	High correlation
`map_name` is highly correlated with `map_height` and 2 other fields	High correlation
`map_height` is highly correlated with `map_name` and 2 other fields	High correlation
`map_width` is highly correlated with `map_name` and 2 other fields	High correlation
`map_thumbnail` is highly correlated with `map_name` and 2 other fields	High correlation
`id` is highly correlated with `map_name` and 1 other fields	High correlation
`position_x` is highly correlated with `position_y` and 4 other fields	High correlation
`position_y` is highly correlated with `position_x` and 4 other fields	High correlation
`faf_player_id` is highly correlated with `rating`	High correlation
`rating` is highly correlated with `faf_player_id` and 2 other fields	High correlation
`map_name` is highly correlated with `id` and 6 other fields	High correlation
`map_thumbnail` is highly correlated with `id` and 6 other fields	High correlation
`map_width` is highly correlated with `position_x` and 4 other fields	High correlation
`map_height` is highly correlated with `position_x` and 4 other fields	High correlation
`blueprint` has 4803912 (73.7%) missing values	Missing
`position_x` has 1799514 (27.6%) missing values	Missing
`position_y` has 1799514 (27.6%) missing values	Missing
`units_number` has 152039 (2.3%) zeros	Zeros
`rating` has 66783 (1.0%) zeros	Zeros

Reproduction

Analysis started	2022-07-28 03:00:28.657234
Analysis finished	2022-07-28 03:07:02.323290
Duration	6 minutes and 33.67 seconds
Software version	pandas-profiling v3.2.0
Download configuration	config.json

id
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	5351
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	16394999.87

Minimum	16260677
Maximum	16462795
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	49.7 MiB

Quantile statistics

Minimum	16260677
5-th percentile	16334755
Q1	16363608
median	16395266
Q3	16428679
95-th percentile	16457339
Maximum	16462795
Range	202118
Interquartile range (IQR)	65071

Descriptive statistics

Standard deviation	40501.70209
Coefficient of variation (CV)	0.002470369162
Kurtosis	-0.2667856269
Mean	16394999.87
Median Absolute Deviation (MAD)	32747
Skewness	-0.2877496599
Sum	1.06810014 × 10¹⁴
Variance	1640387872
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
16371773	10268	0.2%
16356361	9147	0.1%
16379143	8534	0.1%
16405806	7261	0.1%
16392887	7087	0.1%
16334386	6889	0.1%
16333120	6862	0.1%
16456671	6624	0.1%
16434199	6514	0.1%
16391327	6381	0.1%
Other values (5341)	6439225	98.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
16260677	537	< 0.1%
16260678	764	< 0.1%
16260712	1	< 0.1%
16260745	1054	< 0.1%
16260753	1803	< 0.1%
16260762	792	< 0.1%
16260763	1021	< 0.1%
16260764	752	< 0.1%
16260765	953	< 0.1%
16260785	370	< 0.1%

Value	Count	Frequency (%)
16462795	2433	< 0.1%
16462781	2447	< 0.1%
16462769	1907	< 0.1%
16462730	1820	< 0.1%
16462698	2624	< 0.1%
16462680	3117	< 0.1%
16462666	779	< 0.1%
16462648	2638	< 0.1%
16462632	689	< 0.1%
16462609	591	< 0.1%

start_time
Categorical

HIGH CARDINALITY

Distinct	5259
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	49.7 MiB

2022-02-15 19:26:00 UTC	10268
2022-02-13 13:59:40 UTC	9147
2022-02-16 21:34:59 UTC	8534
2022-02-18 19:53:00 UTC	7523
2022-02-20 14:37:24 UTC	7261
Other values (5254)	6472059

Length

Max length	23
Median length	23
Mean length	23
Min length	23

Characters and Unicode

Total characters	149840216
Distinct characters	16
Distinct categories	5 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	128 ?
Unique (%)	< 0.1%

Sample

1st row	2022-02-15 00:36:27 UTC
2nd row	2022-02-10 14:29:08 UTC
3rd row	2022-02-23 15:58:04 UTC
4th row	2022-02-18 19:25:59 UTC
5th row	2022-02-23 19:48:59 UTC

Common Values

Value	Count	Frequency (%)
2022-02-15 19:26:00 UTC	10268	0.2%
2022-02-13 13:59:40 UTC	9147	0.1%
2022-02-16 21:34:59 UTC	8534	0.1%
2022-02-18 19:53:00 UTC	7523	0.1%
2022-02-20 14:37:24 UTC	7261	0.1%
2022-02-18 23:26:03 UTC	7087	0.1%
2022-02-10 18:11:10 UTC	6889	0.1%
2022-02-10 14:50:15 UTC	6862	0.1%
2022-02-27 22:15:54 UTC	6624	0.1%
2022-02-24 19:19:03 UTC	6514	0.1%
Other values (5249)	6438083	98.8%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
utc	6514792	33.3%
2022-02-20	476576	2.4%
2022-02-13	401135	2.1%
2022-02-19	396604	2.0%
2022-02-12	388190	2.0%
2022-02-18	377533	1.9%
2022-02-11	366941	1.9%
2022-02-16	346320	1.8%
2022-02-28	329650	1.7%
2022-02-26	329300	1.7%
Other values (4936)	9617335	49.2%

Most occurring characters

Value	Count	Frequency (%)
2	34847822	23.3%
0	21126463	14.1%
-	13029584	8.7%
	13029584	8.7%
:	13029584	8.7%
1	12250027	8.2%
U	6514792	4.3%
T	6514792	4.3%
C	6514792	4.3%
5	4807308	3.2%
Other values (6)	18175468	12.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	91207088	60.9%
Uppercase Letter	19544376	13.0%
Dash Punctuation	13029584	8.7%
Space Separator	13029584	8.7%
Other Punctuation	13029584	8.7%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
2	34847822	38.2%
0	21126463	23.2%
1	12250027	13.4%
5	4807308	5.3%
3	4430209	4.9%
4	3638488	4.0%
8	2657186	2.9%
9	2496784	2.7%
7	2491705	2.7%
6	2461096	2.7%

Uppercase Letter

Value	Count	Frequency (%)
U	6514792	33.3%
T	6514792	33.3%
C	6514792	33.3%

Dash Punctuation

Value	Count	Frequency (%)
-	13029584	100.0%

Space Separator

Value	Count	Frequency (%)
	13029584	100.0%

Other Punctuation

Value	Count	Frequency (%)
:	13029584	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	130295840	87.0%
Latin	19544376	13.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
2	34847822	26.7%
0	21126463	16.2%
-	13029584	10.0%
	13029584	10.0%
:	13029584	10.0%
1	12250027	9.4%
5	4807308	3.7%
3	4430209	3.4%
4	3638488	2.8%
8	2657186	2.0%
Other values (3)	7449585	5.7%

Latin

Value	Count	Frequency (%)
U	6514792	33.3%
T	6514792	33.3%
C	6514792	33.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	149840216	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
2	34847822	23.3%
0	21126463	14.1%
-	13029584	8.7%
	13029584	8.7%
:	13029584	8.7%
1	12250027	8.2%
U	6514792	4.3%
T	6514792	4.3%
C	6514792	4.3%
5	4807308	3.2%
Other values (6)	18175468	12.1%

offset_ms
Real number (ℝ_≥0)

Distinct	56659
Distinct (%)	0.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	764053.742

Minimum	0
Maximum	19002400
Zeros	2
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	49.7 MiB

Quantile statistics

Minimum	0
5-th percentile	70900
Q1	295500
median	574000
Q3	997800
95-th percentile	2126000
Maximum	19002400
Range	19002400
Interquartile range (IQR)	702300

Descriptive statistics

Standard deviation	723648.6516
Coefficient of variation (CV)	0.947117476
Kurtosis	33.89277023
Mean	764053.742
Median Absolute Deviation (MAD)	324900
Skewness	3.417321711
Sum	4.977651206 × 10¹²
Variance	5.23667371 × 10¹¹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
433400	710	< 0.1%
372700	702	< 0.1%
75000	691	< 0.1%
88800	689	< 0.1%
346400	688	< 0.1%
294500	686	< 0.1%
88900	685	< 0.1%
72800	684	< 0.1%
336600	683	< 0.1%
269400	683	< 0.1%
Other values (56649)	6507891	99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	2	< 0.1%
1800	1	< 0.1%
1900	2	< 0.1%
2000	70	< 0.1%
2100	6	< 0.1%
2200	9	< 0.1%
2300	14	< 0.1%
2400	13	< 0.1%
2500	19	< 0.1%
2600	31	< 0.1%

Value	Count	Frequency (%)
19002400	1	< 0.1%
18992700	1	< 0.1%
18991000	1	< 0.1%
18967900	1	< 0.1%
18889500	1	< 0.1%
18884700	1	< 0.1%
18867200	1	< 0.1%
18867000	1	< 0.1%
18762400	1	< 0.1%
18759300	1	< 0.1%

player
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	49.7 MiB

1	3311433
0	3203359

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	6514792
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	1
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
1	3311433	50.8%
0	3203359	49.2%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
1	3311433	50.8%
0	3203359	49.2%

Most occurring characters

Value	Count	Frequency (%)
1	3311433	50.8%
0	3203359	49.2%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	6514792	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	3311433	50.8%
0	3203359	49.2%

Most occurring scripts

Value	Count	Frequency (%)
Common	6514792	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	3311433	50.8%
0	3203359	49.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	6514792	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	3311433	50.8%
0	3203359	49.2%

type
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	49.7 MiB

issue	6311302
factory_issue	203490

Length

Max length	13
Median length	5
Mean length	5.249880579
Min length	5

Characters and Unicode

Total characters	34201880
Distinct characters	12
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	issue
2nd row	issue
3rd row	issue
4th row	issue
5th row	issue

Common Values

Value	Count	Frequency (%)
issue	6311302	96.9%
factory_issue	203490	3.1%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
issue	6311302	96.9%
factory_issue	203490	3.1%

Most occurring characters

Value	Count	Frequency (%)
s	13029584	38.1%
i	6514792	19.0%
u	6514792	19.0%
e	6514792	19.0%
f	203490	0.6%
a	203490	0.6%
c	203490	0.6%
t	203490	0.6%
o	203490	0.6%
r	203490	0.6%
Other values (2)	406980	1.2%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	33998390	99.4%
Connector Punctuation	203490	0.6%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
s	13029584	38.3%
i	6514792	19.2%
u	6514792	19.2%
e	6514792	19.2%
f	203490	0.6%
a	203490	0.6%
c	203490	0.6%
t	203490	0.6%
o	203490	0.6%
r	203490	0.6%

Connector Punctuation

Value	Count	Frequency (%)
_	203490	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	33998390	99.4%
Common	203490	0.6%

Most frequent character per script

Latin

Value	Count	Frequency (%)
s	13029584	38.3%
i	6514792	19.2%
u	6514792	19.2%
e	6514792	19.2%
f	203490	0.6%
a	203490	0.6%
c	203490	0.6%
t	203490	0.6%
o	203490	0.6%
r	203490	0.6%

Common

Value	Count	Frequency (%)
_	203490	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	34201880	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
s	13029584	38.1%
i	6514792	19.0%
u	6514792	19.0%
e	6514792	19.0%
f	203490	0.6%
a	203490	0.6%
c	203490	0.6%
t	203490	0.6%
o	203490	0.6%
r	203490	0.6%
Other values (2)	406980	1.2%

units_number
Real number (ℝ_≥0)

ZEROS

Distinct	419
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	6.480246184

Minimum	0
Maximum	808
Zeros	152039
Zeros (%)	2.3%
Negative	0
Negative (%)	0.0%
Memory size	49.7 MiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	1
median	1
Q3	5
95-th percentile	30
Maximum	808
Range	808
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	14.46352855
Coefficient of variation (CV)	2.231941217
Kurtosis	101.2997295
Mean	6.480246184
Median Absolute Deviation (MAD)	0
Skewness	6.977743756
Sum	42217456
Variance	209.1936582
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	3620529	55.6%
2	443820	6.8%
3	292261	4.5%
4	226588	3.5%
5	183199	2.8%
0	152039	2.3%
6	150437	2.3%
7	119305	1.8%
8	105060	1.6%
9	92683	1.4%
Other values (409)	1128871	17.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	152039	2.3%
1	3620529	55.6%
2	443820	6.8%
3	292261	4.5%
4	226588	3.5%
5	183199	2.8%
6	150437	2.3%
7	119305	1.8%
8	105060	1.6%
9	92683	1.4%

Value	Count	Frequency (%)
808	1	< 0.1%
784	2	< 0.1%
759	1	< 0.1%
753	1	< 0.1%
703	1	< 0.1%
695	2	< 0.1%
681	1	< 0.1%
670	3	< 0.1%
650	3	< 0.1%
602	1	< 0.1%

blueprint
Categorical

HIGH CARDINALITY
MISSING

Distinct	433
Distinct (%)	< 0.1%
Missing	4803912
Missing (%)	73.7%
Memory size	49.7 MiB

ueb1103	123516
urb1103	120152
xsb1103	62653
url0107	60512
uel0201	55706
Other values (428)	1288341

Length

Max length	22
Median length	7
Mean length	7.004265641
Min length	7

Characters and Unicode

Total characters	11983458
Distinct characters	33
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	4 ?
Unique (%)	< 0.1%

Sample

1st row	urb1103
2nd row	ueb1103
3rd row	ueb1103
4th row	urb1103
5th row	ueb0101

Common Values

Value	Count	Frequency (%)
ueb1103	123516	1.9%
urb1103	120152	1.8%
xsb1103	62653	1.0%
url0107	60512	0.9%
uel0201	55706	0.9%
uel0105	45196	0.7%
url0105	45008	0.7%
ueb0101	42204	0.6%
urb0101	40545	0.6%
uab1103	39087	0.6%
Other values (423)	1076301	16.5%
(Missing)	4803912	73.7%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
ueb1103	123516	7.2%
urb1103	120152	7.0%
xsb1103	62653	3.7%
url0107	60512	3.5%
uel0201	55706	3.3%
uel0105	45196	2.6%
url0105	45008	2.6%
ueb0101	42204	2.5%
urb0101	40545	2.4%
uab1103	39087	2.3%
Other values (423)	1076301	62.9%

Most occurring characters

Value	Count	Frequency (%)
0	2593830	21.6%
1	2416890	20.2%
u	1362522	11.4%
b	1016869	8.5%
2	707520	5.9%
e	639332	5.3%
3	620547	5.2%
r	592247	4.9%
l	542828	4.5%
s	318017	2.7%
Other values (23)	1172856	9.8%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	6841447	57.1%
Lowercase Letter	5140549	42.9%
Connector Punctuation	1462	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
u	1362522	26.5%
b	1016869	19.8%
e	639332	12.4%
r	592247	11.5%
l	542828	10.6%
s	318017	6.2%
x	316030	6.1%
a	314062	6.1%
z	16843	0.3%
d	15555	0.3%
Other values (12)	6244	0.1%

Decimal Number

Value	Count	Frequency (%)
0	2593830	37.9%
1	2416890	35.3%
2	707520	10.3%
3	620547	9.1%
5	210818	3.1%
4	132218	1.9%
7	67669	1.0%
6	41346	0.6%
8	25337	0.4%
9	25272	0.4%

Connector Punctuation

Value	Count	Frequency (%)
_	1462	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	6842909	57.1%
Latin	5140549	42.9%

Most frequent character per script

Latin

Value	Count	Frequency (%)
u	1362522	26.5%
b	1016869	19.8%
e	639332	12.4%
r	592247	11.5%
l	542828	10.6%
s	318017	6.2%
x	316030	6.1%
a	314062	6.1%
z	16843	0.3%
d	15555	0.3%
Other values (12)	6244	0.1%

Common

Value	Count	Frequency (%)
0	2593830	37.9%
1	2416890	35.3%
2	707520	10.3%
3	620547	9.1%
5	210818	3.1%
4	132218	1.9%
7	67669	1.0%
6	41346	0.6%
8	25337	0.4%
9	25272	0.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	11983458	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	2593830	21.6%
1	2416890	20.2%
u	1362522	11.4%
b	1016869	8.5%
2	707520	5.9%
e	639332	5.3%
3	620547	5.2%
r	592247	4.9%
l	542828	4.5%
s	318017	2.7%
Other values (23)	1172856	9.8%

position_x
Real number (ℝ)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
MISSING

Distinct	3281922
Distinct (%)	69.6%
Missing	1799514
Missing (%)	27.6%
Infinite	0
Infinite (%)	0.0%
Mean	247.2727416

Minimum	-0.9999847412
Maximum	1023.454834
Zeros	6
Zeros (%)	< 0.1%
Negative	216
Negative (%)	< 0.1%
Memory size	49.7 MiB

Quantile statistics

Minimum	-0.9999847412
5-th percentile	31.07578087
Q1	113.3611832
median	206.1904907
Q3	346.6536331
95-th percentile	619.0763
Maximum	1023.454834
Range	1024.454819
Interquartile range (IQR)	233.29245

Descriptive statistics

Standard deviation	182.2267471
Coefficient of variation (CV)	0.7369463609
Kurtosis	1.474881294
Mean	247.2727416
Median Absolute Deviation (MAD)	110.4556847
Skewness	1.205535866
Sum	1165959719
Variance	33206.58736
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
38.5	7536	0.1%
30.5	7335	0.1%
211.5	7228	0.1%
18.5	6844	0.1%
50.5	6083	0.1%
209.5	5533	0.1%
31.5	5326	0.1%
46.5	5307	0.1%
22.5	5255	0.1%
489.5	5244	0.1%
Other values (3281912)	4653587	71.4%
(Missing)	1799514	27.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-0.9999847412	1	< 0.1%
-0.9991149902	1	< 0.1%
-0.9983062744	1	< 0.1%
-0.9970092773	1	< 0.1%
-0.995010376	1	< 0.1%
-0.9896697998	1	< 0.1%
-0.9882507324	1	< 0.1%
-0.9871063232	1	< 0.1%
-0.9868164062	1	< 0.1%
-0.9838790894	1	< 0.1%

Value	Count	Frequency (%)
1023.454834	1	< 0.1%
1023.108765	1	< 0.1%
1022.73291	1	< 0.1%
1022.675659	1	< 0.1%
1022.562012	1	< 0.1%
1022.361328	1	< 0.1%
1022.274414	1	< 0.1%
1021.741455	1	< 0.1%
1021.69104	1	< 0.1%
1021.661133	1	< 0.1%

position_y
Real number (ℝ)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
MISSING

Distinct	3228670
Distinct (%)	68.5%
Missing	1799514
Missing (%)	27.6%
Infinite	0
Infinite (%)	0.0%
Mean	252.9292453

Minimum	-0.9962081909
Maximum	1023.842896
Zeros	6
Zeros (%)	< 0.1%
Negative	66
Negative (%)	< 0.1%
Memory size	49.7 MiB

Quantile statistics

Minimum	-0.9962081909
5-th percentile	34.90284214
Q1	122.7977924
median	212.5
Q3	340.1143799
95-th percentile	664.7243378
Maximum	1023.842896
Range	1024.839104
Interquartile range (IQR)	217.3165874

Descriptive statistics

Standard deviation	183.4765731
Coefficient of variation (CV)	0.7254067155
Kurtosis	1.893313646
Mean	252.9292453
Median Absolute Deviation (MAD)	104.5398636
Skewness	1.327383004
Sum	1192631706
Variance	33663.65287
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
15.5	8066	0.1%
120.5	7475	0.1%
130.5	6871	0.1%
27.5	6787	0.1%
35.5	6520	0.1%
30.5	6220	0.1%
47.5	5751	0.1%
188.5	5351	0.1%
235.5	5201	0.1%
221.5	5135	0.1%
Other values (3228660)	4651901	71.4%
(Missing)	1799514	27.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-0.9962081909	1	< 0.1%
-0.9352416992	1	< 0.1%
-0.9167938232	1	< 0.1%
-0.8918609619	1	< 0.1%
-0.8843841553	1	< 0.1%
-0.8827590942	1	< 0.1%
-0.8789749146	1	< 0.1%
-0.8687744141	1	< 0.1%
-0.8659133911	1	< 0.1%
-0.860786438	1	< 0.1%

Value	Count	Frequency (%)
1023.842896	1	< 0.1%
1023.67572	1	< 0.1%
1023.606934	1	< 0.1%
1022.105347	1	< 0.1%
1021.824341	1	< 0.1%
1021.669312	1	< 0.1%
1021.389832	1	< 0.1%
1021.33374	1	< 0.1%
1021.258545	1	< 0.1%
1021.048462	1	< 0.1%

command_name
Categorical

Distinct	31
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	49.7 MiB

Move	3379522
BuildMobile	780535
BuildFactory	689989
Reclaim	450781
Attack	400288
Other values (26)	813677

Length

Max length	28
Median length	4
Mean length	6.535027826
Min length	4

Characters and Unicode

Total characters	42574347
Distinct characters	37
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Stop
2nd row	TransportReverseLoadUnits
3rd row	Stop
4th row	TransportLoadUnits
5th row	Capture

Common Values

Value	Count	Frequency (%)
Move	3379522	51.9%
BuildMobile	780535	12.0%
BuildFactory	689989	10.6%
Reclaim	450781	6.9%
Attack	400288	6.1%
Guard	248961	3.8%
AggressiveMove	187533	2.9%
Patrol	129959	2.0%
Upgrade	84634	1.3%
Repair	40850	0.6%
Other values (21)	121740	1.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
move	3379522	51.9%
buildmobile	780535	12.0%
buildfactory	689989	10.6%
reclaim	450781	6.9%
attack	400288	6.1%
guard	248961	3.8%
aggressivemove	187533	2.9%
patrol	129959	2.0%
upgrade	84634	1.3%
repair	40850	0.6%
Other values (21)	121740	1.9%

Most occurring characters

Value	Count	Frequency (%)
e	5358594	12.6%
o	5285470	12.4%
M	4368772	10.3%
v	3787669	8.9%
i	2999563	7.0%
l	2849076	6.7%
a	2117079	5.0%
d	1826868	4.3%
t	1736121	4.1%
u	1727569	4.1%
Other values (27)	10517566	24.7%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	34317155	80.6%
Uppercase Letter	8257192	19.4%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	5358594	15.6%
o	5285470	15.4%
v	3787669	11.0%
i	2999563	8.7%
l	2849076	8.3%
a	2117079	6.2%
d	1826868	5.3%
t	1736121	5.1%
u	1727569	5.0%
c	1589704	4.6%
Other values (11)	5039442	14.7%

Uppercase Letter

Value	Count	Frequency (%)
M	4368772	52.9%
B	1470524	17.8%
F	712745	8.6%
A	592775	7.2%
R	492399	6.0%
G	248961	3.0%
P	129959	1.6%
U	119025	1.4%
S	60551	0.7%
T	28175	0.3%
Other values (6)	33306	0.4%

Most occurring scripts

Value	Count	Frequency (%)
Latin	42574347	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	5358594	12.6%
o	5285470	12.4%
M	4368772	10.3%
v	3787669	8.9%
i	2999563	7.0%
l	2849076	6.7%
a	2117079	5.0%
d	1826868	4.3%
t	1736121	4.1%
u	1727569	4.1%
Other values (27)	10517566	24.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	42574347	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	5358594	12.6%
o	5285470	12.4%
M	4368772	10.3%
v	3787669	8.9%
i	2999563	7.0%
l	2849076	6.7%
a	2117079	5.0%
d	1826868	4.3%
t	1736121	4.1%
u	1727569	4.1%
Other values (27)	10517566	24.7%

faf_player_id
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	1130
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	240504.9518

Minimum	145
Maximum	437311
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	49.7 MiB

Quantile statistics

Minimum	145
5-th percentile	15289
Q1	105808
median	248189
Q3	383675
95-th percentile	432747
Maximum	437311
Range	437166
Interquartile range (IQR)	277867

Descriptive statistics

Standard deviation	147190.9575
Coefficient of variation (CV)	0.6120080121
Kurtosis	-1.464348236
Mean	240504.9518
Median Absolute Deviation (MAD)	138377
Skewness	-0.1675221872
Sum	1.566839736 × 10¹²
Variance	2.166517796 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
64928	126011	1.9%
119070	115783	1.8%
2642	92980	1.4%
403743	76173	1.2%
33632	74668	1.1%
177382	65115	1.0%
342398	64206	1.0%
62848	62835	1.0%
395919	62674	1.0%
151257	61796	0.9%
Other values (1120)	5712551	87.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
145	22627	0.3%
259	28793	0.4%
434	4838	0.1%
435	18794	0.3%
606	3096	< 0.1%
648	13001	0.2%
899	381	< 0.1%
1294	10512	0.2%
1297	247	< 0.1%
1499	6587	0.1%

Value	Count	Frequency (%)
437311	244	< 0.1%
437302	748	< 0.1%
437301	1315	< 0.1%
437263	20	< 0.1%
437218	136	< 0.1%
437177	3495	0.1%
437109	426	< 0.1%
437063	4356	0.1%
437059	5	< 0.1%
437048	207	< 0.1%

login
Categorical

HIGH CARDINALITY

Distinct	1144
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	49.7 MiB

Morax	126011
Cast_Away	115783
nemir	92980
indicator2020	76173
silentNoob	74668
Other values (1139)	6029177

Length

Max length	16
Median length	13
Mean length	8.527673025
Min length	2

Characters and Unicode

Total characters	55556016
Distinct characters	64
Distinct categories	5 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	TheWreck
2nd row	silentNoob
3rd row	YellowNoob
4th row	Cast_Away
5th row	Swkoll

Common Values

Value	Count	Frequency (%)
Morax	126011	1.9%
Cast_Away	115783	1.8%
nemir	92980	1.4%
indicator2020	76173	1.2%
silentNoob	74668	1.1%
C_Buck	65115	1.0%
hegesso	64206	1.0%
Chenbro101	62835	1.0%
Shadowrear	62674	1.0%
Solstice245	61796	0.9%
Other values (1134)	5712551	87.7%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
morax	126011	1.9%
cast_away	115783	1.8%
nemir	92980	1.4%
indicator2020	76173	1.2%
silentnoob	74668	1.1%
c_buck	65115	1.0%
hegesso	64206	1.0%
chenbro101	62835	1.0%
shadowrear	62674	1.0%
solstice245	61796	0.9%
Other values (1133)	5712551	87.7%

Most occurring characters

Value	Count	Frequency (%)
a	5019627	9.0%
e	4291499	7.7%
o	3862434	7.0%
r	3822416	6.9%
n	2817746	5.1%
i	2747953	4.9%
t	2362360	4.3%
s	2247427	4.0%
l	1803406	3.2%
h	1452863	2.6%
Other values (54)	25128285	45.2%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	42154282	75.9%
Uppercase Letter	9289601	16.7%
Decimal Number	3010963	5.4%
Connector Punctuation	875066	1.6%
Dash Punctuation	226104	0.4%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	5019627	11.9%
e	4291499	10.2%
o	3862434	9.2%
r	3822416	9.1%
n	2817746	6.7%
i	2747953	6.5%
t	2362360	5.6%
s	2247427	5.3%
l	1803406	4.3%
h	1452863	3.4%
Other values (16)	11726551	27.8%

Uppercase Letter

Value	Count	Frequency (%)
S	794395	8.6%
N	662464	7.1%
A	607051	6.5%
T	580264	6.2%
C	559206	6.0%
B	500819	5.4%
R	497703	5.4%
M	479090	5.2%
L	454635	4.9%
D	445138	4.8%
Other values (16)	3708836	39.9%

Decimal Number

Value	Count	Frequency (%)
0	608636	20.2%
1	562229	18.7%
2	495445	16.5%
4	259906	8.6%
3	231177	7.7%
6	191763	6.4%
5	188169	6.2%
7	170160	5.7%
9	160534	5.3%
8	142944	4.7%

Connector Punctuation

Value	Count	Frequency (%)
_	875066	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	226104	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	51443883	92.6%
Common	4112133	7.4%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	5019627	9.8%
e	4291499	8.3%
o	3862434	7.5%
r	3822416	7.4%
n	2817746	5.5%
i	2747953	5.3%
t	2362360	4.6%
s	2247427	4.4%
l	1803406	3.5%
h	1452863	2.8%
Other values (42)	21016152	40.9%

Common

Value	Count	Frequency (%)
_	875066	21.3%
0	608636	14.8%
1	562229	13.7%
2	495445	12.0%
4	259906	6.3%
3	231177	5.6%
-	226104	5.5%
6	191763	4.7%
5	188169	4.6%
7	170160	4.1%
Other values (2)	303478	7.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	55556016	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	5019627	9.0%
e	4291499	7.7%
o	3862434	7.0%
r	3822416	6.9%
n	2817746	5.1%
i	2747953	4.9%
t	2362360	4.3%
s	2247427	4.0%
l	1803406	3.2%
h	1452863	2.6%
Other values (54)	25128285	45.2%

rating
Real number (ℝ)

HIGH CORRELATION
ZEROS

Distinct	2181
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	823.9001541

Minimum	-602
Maximum	2283
Zeros	66783
Zeros (%)	1.0%
Negative	261154
Negative (%)	4.0%
Memory size	49.7 MiB

Quantile statistics

Minimum	-602
5-th percentile	0
Q1	453
median	760
Q3	1210
95-th percentile	1754
Maximum	2283
Range	2885
Interquartile range (IQR)	757

Descriptive statistics

Standard deviation	522.7184424
Coefficient of variation (CV)	0.6344439187
Kurtosis	-0.4357332748
Mean	823.9001541
Median Absolute Deviation (MAD)	352
Skewness	0.292974887
Sum	5367538133
Variance	273234.57
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	66783	1.0%
493	14836	0.2%
583	13957	0.2%
835	13666	0.2%
802	13327	0.2%
560	13099	0.2%
431	12752	0.2%
760	12367	0.2%
438	12152	0.2%
691	11957	0.2%
Other values (2171)	6329896	97.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-602	653	< 0.1%
-600	173	< 0.1%
-596	254	< 0.1%
-586	1453	< 0.1%
-565	356	< 0.1%
-564	1924	< 0.1%
-544	19	< 0.1%
-535	84	< 0.1%
-534	185	< 0.1%
-517	396	< 0.1%

Value	Count	Frequency (%)
2283	901	< 0.1%
2277	644	< 0.1%
2271	902	< 0.1%
2230	1113	< 0.1%
2226	928	< 0.1%
2223	2078	< 0.1%
2217	495	< 0.1%
2216	1000	< 0.1%
2209	559	< 0.1%
2207	1763	< 0.1%

faction
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	49.7 MiB

UEF	2282944
Cybran	2254063
Seraphim	1221570
Aeon	756215

Length

Max length	8
Median length	6
Mean length	5.091586961
Min length	3

Characters and Unicode

Total characters	33170630
Distinct characters	17
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	UEF
2nd row	Cybran
3rd row	UEF
4th row	Cybran
5th row	UEF

Common Values

Value	Count	Frequency (%)
UEF	2282944	35.0%
Cybran	2254063	34.6%
Seraphim	1221570	18.8%
Aeon	756215	11.6%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
uef	2282944	35.0%
cybran	2254063	34.6%
seraphim	1221570	18.8%
aeon	756215	11.6%

Most occurring characters

Value	Count	Frequency (%)
r	3475633	10.5%
a	3475633	10.5%
n	3010278	9.1%
E	2282944	6.9%
U	2282944	6.9%
F	2282944	6.9%
b	2254063	6.8%
y	2254063	6.8%
C	2254063	6.8%
e	1977785	6.0%
Other values (7)	7620280	23.0%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	22089950	66.6%
Uppercase Letter	11080680	33.4%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
r	3475633	15.7%
a	3475633	15.7%
n	3010278	13.6%
b	2254063	10.2%
y	2254063	10.2%
e	1977785	9.0%
p	1221570	5.5%
h	1221570	5.5%
i	1221570	5.5%
m	1221570	5.5%

Uppercase Letter

Value	Count	Frequency (%)
E	2282944	20.6%
U	2282944	20.6%
F	2282944	20.6%
C	2254063	20.3%
S	1221570	11.0%
A	756215	6.8%

Most occurring scripts

Value	Count	Frequency (%)
Latin	33170630	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
r	3475633	10.5%
a	3475633	10.5%
n	3010278	9.1%
E	2282944	6.9%
U	2282944	6.9%
F	2282944	6.9%
b	2254063	6.8%
y	2254063	6.8%
C	2254063	6.8%
e	1977785	6.0%
Other values (7)	7620280	23.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	33170630	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
r	3475633	10.5%
a	3475633	10.5%
n	3010278	9.1%
E	2282944	6.9%
U	2282944	6.9%
F	2282944	6.9%
b	2254063	6.8%
y	2254063	6.8%
C	2254063	6.8%
e	1977785	6.0%
Other values (7)	7620280	23.0%

map_name
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	24
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	49.7 MiB

Oracle	1011204
Loki - FAF version	1007624
Open Palms	954503
Stickleback Ridge	740717
Esgaroth's Ruins	706330
Other values (19)	2094414

Length

Max length	35
Median length	28
Mean length	17.04001371
Min length	5

Characters and Unicode

Total characters	111012145
Distinct characters	48
Distinct categories	7 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Norfair
2nd row	Desert Planet II v2
3rd row	Norfair
4th row	Desert Planet II v2
5th row	Forbidden Pass - FAF version

Common Values

Value	Count	Frequency (%)
Oracle	1011204	15.5%
Loki - FAF version	1007624	15.5%
Open Palms	954503	14.7%
Stickleback Ridge	740717	11.4%
Esgaroth's Ruins	706330	10.8%
Theta Passage - FAF version	675199	10.4%
Seraphim Glaciers - FAF version	627190	9.6%
Point of Reach v4	245451	3.8%
TAG Craftious Maximus - FAF version	178688	2.7%
Tamara Pass	175544	2.7%
Other values (14)	192342	3.0%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
	2550329	13.1%
faf	2550329	13.1%
version	2550329	13.1%
oracle	1011204	5.2%
loki	1007624	5.2%
open	954503	4.9%
palms	954503	4.9%
stickleback	740717	3.8%
ridge	740717	3.8%
ruins	706330	3.6%
Other values (37)	5632072	29.0%

Most occurring characters

Value	Count	Frequency (%)
	12883865	11.6%
e	9101242	8.2%
s	8488667	7.6%
a	8148552	7.3%
i	7724485	7.0%
r	6109191	5.5%
F	5138047	4.6%
o	5065233	4.6%
n	4583776	4.1%
l	3378155	3.0%
Other values (38)	40390932	36.4%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	75341874	67.9%
Uppercase Letter	19238258	17.3%
Space Separator	12883865	11.6%
Dash Punctuation	2550329	2.3%
Other Punctuation	706330	0.6%
Decimal Number	289992	0.3%
Connector Punctuation	1497	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	9101242	12.1%
s	8488667	11.3%
a	8148552	10.8%
i	7724485	10.3%
r	6109191	8.1%
o	5065233	6.7%
n	4583776	6.1%
l	3378155	4.5%
c	3365279	4.5%
v	2850288	3.8%
Other values (14)	16527006	21.9%

Uppercase Letter

Value	Count	Frequency (%)
F	5138047	26.7%
A	2751309	14.3%
P	2156536	11.2%
O	1968328	10.2%
R	1700246	8.8%
S	1397792	7.3%
T	1037179	5.4%
L	1010245	5.3%
G	805878	4.2%
E	720515	3.7%
Other values (8)	552183	2.9%

Decimal Number

Value	Count	Frequency (%)
4	245451	84.6%
2	44541	15.4%

Space Separator

Value	Count	Frequency (%)
	12883865	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	2550329	100.0%

Other Punctuation

Value	Count	Frequency (%)
'	706330	100.0%

Connector Punctuation

Value	Count	Frequency (%)
_	1497	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	94580132	85.2%
Common	16432013	14.8%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	9101242	9.6%
s	8488667	9.0%
a	8148552	8.6%
i	7724485	8.2%
r	6109191	6.5%
F	5138047	5.4%
o	5065233	5.4%
n	4583776	4.8%
l	3378155	3.6%
c	3365279	3.6%
Other values (32)	33477505	35.4%

Common

Value	Count	Frequency (%)
	12883865	78.4%
-	2550329	15.5%
'	706330	4.3%
4	245451	1.5%
2	44541	0.3%
_	1497	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	111012145	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	12883865	11.6%
e	9101242	8.2%
s	8488667	7.6%
a	8148552	7.3%
i	7724485	7.0%
r	6109191	5.5%
F	5138047	4.6%
o	5065233	4.6%
n	4583776	4.1%
l	3378155	3.0%
Other values (38)	40390932	36.4%

map_thumbnail
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	24
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	49.7 MiB

https://content.faforever.com/maps/previews/large/oracle.v0005.png	1011204
https://content.faforever.com/maps/previews/large/loki_-_faf_version.v0003.png	1007624
https://content.faforever.com/maps/previews/large/scmp_007.png	954503
https://content.faforever.com/maps/previews/large/stickleback_ridge.v0003.png	740717
https://content.faforever.com/maps/previews/large/esgaroths ruins.png	706330
Other values (19)	2094414

Length

Max length	95
Median length	88
Mean length	74.80420373
Min length	62

Characters and Unicode

Total characters	487333828
Distinct characters	38
Distinct categories	6 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	https://content.faforever.com/maps/previews/large/norfair.v0005.png
2nd row	https://content.faforever.com/maps/previews/large/desert planet ii v2.png
3rd row	https://content.faforever.com/maps/previews/large/norfair.v0005.png
4th row	https://content.faforever.com/maps/previews/large/desert planet ii v2.png
5th row	https://content.faforever.com/maps/previews/large/forbidden_pass_-_faf_version.v0004.png

Common Values

Value	Count	Frequency (%)
https://content.faforever.com/maps/previews/large/oracle.v0005.png	1011204	15.5%
https://content.faforever.com/maps/previews/large/loki_-_faf_version.v0003.png	1007624	15.5%
https://content.faforever.com/maps/previews/large/scmp_007.png	954503	14.7%
https://content.faforever.com/maps/previews/large/stickleback_ridge.v0003.png	740717	11.4%
https://content.faforever.com/maps/previews/large/esgaroths ruins.png	706330	10.8%
https://content.faforever.com/maps/previews/large/theta_passage_-_faf_version.v0001.png	675199	10.4%
https://content.faforever.com/maps/previews/large/seraphim_glaciers_-_faf_version.v0001.png	627190	9.6%
https://content.faforever.com/maps/previews/large/point of reach v4.png	245451	3.8%
https://content.faforever.com/maps/previews/large/tag_craftious_maximus_-_faf_version.v0004.png	178688	2.7%
https://content.faforever.com/maps/previews/large/tamara_pass.v0001.png	175544	2.7%
Other values (14)	192342	3.0%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
https://content.faforever.com/maps/previews/large/oracle.v0005.png	1011204	12.5%
https://content.faforever.com/maps/previews/large/loki_-_faf_version.v0003.png	1007624	12.4%
https://content.faforever.com/maps/previews/large/scmp_007.png	954503	11.8%
https://content.faforever.com/maps/previews/large/stickleback_ridge.v0003.png	740717	9.1%
https://content.faforever.com/maps/previews/large/esgaroths	706330	8.7%
ruins.png	706330	8.7%
https://content.faforever.com/maps/previews/large/theta_passage_-_faf_version.v0001.png	675199	8.3%
https://content.faforever.com/maps/previews/large/seraphim_glaciers_-_faf_version.v0001.png	627190	7.7%
https://content.faforever.com/maps/previews/large/point	245451	3.0%
of	245451	3.0%
Other values (23)	1181468	14.6%

Most occurring characters

Value	Count	Frequency (%)
e	47941539	9.8%
/	39088752	8.0%
r	33854138	6.9%
t	29776845	6.1%
a	29467316	6.0%
s	29408417	6.0%
p	28842894	5.9%
o	25608967	5.3%
.	24082667	4.9%
n	23188865	4.8%
Other values (28)	176073428	36.1%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	380828233	78.1%
Other Punctuation	69686211	14.3%
Decimal Number	21383693	4.4%
Connector Punctuation	11298687	2.3%
Dash Punctuation	2550329	0.5%
Space Separator	1586675	0.3%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	47941539	12.6%
r	33854138	8.9%
t	29776845	7.8%
a	29467316	7.7%
s	29408417	7.7%
p	28842894	7.6%
o	25608967	6.7%
n	23188865	6.1%
v	20419660	5.4%
f	18650105	4.9%
Other values (14)	93669487	24.6%

Decimal Number

Value	Count	Frequency (%)
0	15549555	72.7%
3	1761812	8.2%
1	1500148	7.0%
5	1055354	4.9%
7	954503	4.5%
4	459761	2.2%
2	73168	0.3%
8	29392	0.1%

Other Punctuation

Value	Count	Frequency (%)
/	39088752	56.1%
.	24082667	34.6%
:	6514792	9.3%

Connector Punctuation

Value	Count	Frequency (%)
_	11298687	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	2550329	100.0%

Space Separator

Value	Count	Frequency (%)
	1586675	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	380828233	78.1%
Common	106505595	21.9%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	47941539	12.6%
r	33854138	8.9%
t	29776845	7.8%
a	29467316	7.7%
s	29408417	7.7%
p	28842894	7.6%
o	25608967	6.7%
n	23188865	6.1%
v	20419660	5.4%
f	18650105	4.9%
Other values (14)	93669487	24.6%

Common

Value	Count	Frequency (%)
/	39088752	36.7%
.	24082667	22.6%
0	15549555	14.6%
_	11298687	10.6%
:	6514792	6.1%
-	2550329	2.4%
3	1761812	1.7%
	1586675	1.5%
1	1500148	1.4%
5	1055354	1.0%
Other values (4)	1516824	1.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	487333828	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	47941539	9.8%
/	39088752	8.0%
r	33854138	6.9%
t	29776845	6.1%
a	29467316	6.0%
s	29408417	6.0%
p	28842894	5.9%
o	25608967	5.3%
.	24082667	4.9%
n	23188865	4.8%
Other values (28)	176073428	36.1%

map_width
Categorical

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	49.7 MiB

512	3441258
256	2156743
1024	916791

Length

Max length	4
Median length	3
Mean length	3.140724524
Min length	3

Characters and Unicode

Total characters	20461167
Distinct characters	6
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1024
2nd row	512
3rd row	1024
4th row	512
5th row	512

Common Values

Value	Count	Frequency (%)
512	3441258	52.8%
256	2156743	33.1%
1024	916791	14.1%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
512	3441258	52.8%
256	2156743	33.1%
1024	916791	14.1%

Most occurring characters

Value	Count	Frequency (%)
2	6514792	31.8%
5	5598001	27.4%
1	4358049	21.3%
6	2156743	10.5%
0	916791	4.5%
4	916791	4.5%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	20461167	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
2	6514792	31.8%
5	5598001	27.4%
1	4358049	21.3%
6	2156743	10.5%
0	916791	4.5%
4	916791	4.5%

Most occurring scripts

Value	Count	Frequency (%)
Common	20461167	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
2	6514792	31.8%
5	5598001	27.4%
1	4358049	21.3%
6	2156743	10.5%
0	916791	4.5%
4	916791	4.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	20461167	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
2	6514792	31.8%
5	5598001	27.4%
1	4358049	21.3%
6	2156743	10.5%
0	916791	4.5%
4	916791	4.5%

map_height
Categorical

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	49.7 MiB

512	3441258
256	2156743
1024	916791

Length

Max length	4
Median length	3
Mean length	3.140724524
Min length	3

Characters and Unicode

Total characters	20461167
Distinct characters	6
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1024
2nd row	512
3rd row	1024
4th row	512
5th row	512

Common Values

Value	Count	Frequency (%)
512	3441258	52.8%
256	2156743	33.1%
1024	916791	14.1%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
512	3441258	52.8%
256	2156743	33.1%
1024	916791	14.1%

Most occurring characters

Value	Count	Frequency (%)
2	6514792	31.8%
5	5598001	27.4%
1	4358049	21.3%
6	2156743	10.5%
0	916791	4.5%
4	916791	4.5%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	20461167	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
2	6514792	31.8%
5	5598001	27.4%
1	4358049	21.3%
6	2156743	10.5%
0	916791	4.5%
4	916791	4.5%

Most occurring scripts

Value	Count	Frequency (%)
Common	20461167	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
2	6514792	31.8%
5	5598001	27.4%
1	4358049	21.3%
6	2156743	10.5%
0	916791	4.5%
4	916791	4.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	20461167	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
2	6514792	31.8%
5	5598001	27.4%
1	4358049	21.3%
6	2156743	10.5%
0	916791	4.5%
4	916791	4.5%

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

The dendrogram allows you to more fully correlate variable completion, revealing trends deeper than the pairwise ones visible in the correlation heatmap.

First rows

	id	start_time	offset_ms	player	type	units_number	blueprint	position_x	position_y	command_name	faf_player_id	login	rating	faction	map_name	map_thumbnail	map_width	map_height
0	16367281	2022-02-15 00:36:27 UTC	790800	0	issue	15	NaN	NaN	NaN	Stop	44051	TheWreck	1885	UEF	Norfair	https://content.faforever.com/maps/previews/large/norfair.v0005.png	1024	1024
1	16333036	2022-02-10 14:29:08 UTC	1113200	0	issue	1	NaN	NaN	NaN	TransportReverseLoadUnits	33632	silentNoob	1712	Cybran	Desert Planet II v2	https://content.faforever.com/maps/previews/large/desert planet ii v2.png	512	512
2	16426829	2022-02-23 15:58:04 UTC	186500	1	issue	1	NaN	NaN	NaN	Stop	206383	YellowNoob	1987	UEF	Norfair	https://content.faforever.com/maps/previews/large/norfair.v0005.png	1024	1024
3	16391098	2022-02-18 19:25:59 UTC	1290800	0	issue	9	NaN	NaN	NaN	TransportLoadUnits	119070	Cast_Away	1666	Cybran	Desert Planet II v2	https://content.faforever.com/maps/previews/large/desert planet ii v2.png	512	512
4	16428462	2022-02-23 19:48:59 UTC	455400	0	issue	1	NaN	NaN	NaN	Capture	25711	Swkoll	2149	UEF	Forbidden Pass - FAF version	https://content.faforever.com/maps/previews/large/forbidden_pass_-_faf_version.v0004.png	512	512
5	16341419	2022-02-11 18:59:14 UTC	1070200	0	issue	4	NaN	303.411865	111.591949	FormMove	119070	Cast_Away	1636	Cybran	Desert Planet II v2	https://content.faforever.com/maps/previews/large/desert planet ii v2.png	512	512
6	16452080	2022-02-27 11:48:59 UTC	31100	0	issue	1	NaN	NaN	NaN	Stop	206383	YellowNoob	1955	UEF	Forbidden Pass - FAF version	https://content.faforever.com/maps/previews/large/forbidden_pass_-_faf_version.v0004.png	512	512
7	16379143	2022-02-16 21:34:59 UTC	2274900	1	issue	15	NaN	NaN	NaN	TransportLoadUnits	64928	Morax	1811	Cybran	Desert Planet II v2	https://content.faforever.com/maps/previews/large/desert planet ii v2.png	512	512
8	16261749	2022-02-01 05:38:13 UTC	189100	1	issue	6	NaN	NaN	NaN	TransportLoadUnits	287686	demonstreamer666	1553	Cybran	White Fire - FAF version	https://content.faforever.com/maps/previews/large/white_fire_-_faf_version.v0002.png	512	512
9	16453036	2022-02-27 14:13:16 UTC	703200	0	issue	1	NaN	510.855286	450.782532	Ferry	229724	Novdino	1545	Aeon	Norfair	https://content.faforever.com/maps/previews/large/norfair.v0005.png	1024	1024

Last rows

	id	start_time	offset_ms	player	type	units_number	blueprint	position_x	position_y	command_name	faf_player_id	login	rating	faction	map_name	map_thumbnail	map_width	map_height
6514782	16459191	2022-02-28 11:57:50 UTC	1007000	1	issue	8	NaN	403.683502	249.417191	AggressiveMove	298933	CheeseBerry	1278	Seraphim	TAG Craftious Maximus - FAF version	https://content.faforever.com/maps/previews/large/tag_craftious_maximus_-_faf_version.v0004.png	512	512
6514783	16380003	2022-02-17 00:37:57 UTC	637600	0	issue	5	NaN	188.160904	330.224243	AggressiveMove	64928	Morax	1798	Cybran	TAG Craftious Maximus - FAF version	https://content.faforever.com/maps/previews/large/tag_craftious_maximus_-_faf_version.v0004.png	512	512
6514784	16426709	2022-02-23 15:31:00 UTC	771200	0	issue	25	NaN	242.952194	161.408295	AggressiveMove	434782	Kalkbrenner	1258	Aeon	TAG Craftious Maximus - FAF version	https://content.faforever.com/maps/previews/large/tag_craftious_maximus_-_faf_version.v0004.png	512	512
6514785	16349509	2022-02-12 18:20:12 UTC	177700	1	issue	4	NaN	293.124359	147.393021	AggressiveMove	219084	Conorach	1388	Cybran	TAG Craftious Maximus - FAF version	https://content.faforever.com/maps/previews/large/tag_craftious_maximus_-_faf_version.v0004.png	512	512
6514786	16371595	2022-02-15 19:02:03 UTC	259700	1	issue	1	NaN	208.845963	323.309753	AggressiveMove	373105	grimplex	1907	UEF	TAG Craftious Maximus - FAF version	https://content.faforever.com/maps/previews/large/tag_craftious_maximus_-_faf_version.v0004.png	512	512
6514787	16415008	2022-02-21 19:37:00 UTC	445100	1	issue	2	NaN	392.935974	224.796936	AggressiveMove	64928	Morax	1801	Cybran	TAG Craftious Maximus - FAF version	https://content.faforever.com/maps/previews/large/tag_craftious_maximus_-_faf_version.v0004.png	512	512
6514788	16367360	2022-02-15 01:03:28 UTC	387500	0	issue	2	NaN	204.560776	174.036285	AggressiveMove	275960	RowanMorseYT	1629	Seraphim	TAG Craftious Maximus - FAF version	https://content.faforever.com/maps/previews/large/tag_craftious_maximus_-_faf_version.v0004.png	512	512
6514789	16379427	2022-02-16 22:25:56 UTC	1353000	1	issue	1	NaN	378.457092	104.579559	AggressiveMove	62848	Chenbro101	1274	Cybran	TAG Craftious Maximus - FAF version	https://content.faforever.com/maps/previews/large/tag_craftious_maximus_-_faf_version.v0004.png	512	512
6514790	16339025	2022-02-11 12:59:11 UTC	149200	0	factory_issue	1	NaN	122.546814	180.407104	AggressiveMove	62848	Chenbro101	1254	Cybran	TAG Craftious Maximus - FAF version	https://content.faforever.com/maps/previews/large/tag_craftious_maximus_-_faf_version.v0004.png	512	512
6514791	16360012	2022-02-13 21:00:26 UTC	797700	1	factory_issue	1	NaN	455.219452	213.843216	AggressiveMove	131692	o-o-o	1087	Aeon	TAG Craftious Maximus - FAF version	https://content.faforever.com/maps/previews/large/tag_craftious_maximus_-_faf_version.v0004.png	512	512

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Uppercase Letter

Dash Punctuation

Space Separator

Other Punctuation

Most occurring scripts

Most frequent character per script

Common

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Category Frequency Plot

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Category Frequency Plot

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Connector Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Decimal Number

Connector Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category